package com.ship.dispatch.mapper.orderPay;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ship.dispatch.bean.ConResourceMemorandum;
import com.ship.dispatch.bean.orderPay.SpPaymentOrder;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

public interface SpPaymentOrderMapper extends BaseMapper<SpPaymentOrder> {

    @Select("SELECT * FROM sp_payment_order WHERE pay_order_number like '%${identifying}%'  ORDER BY create_date DESC  LIMIT 1")
    SpPaymentOrder getMaxPayOrderNumber(@Param("identifying") String identifying);
}
